BUFFER SORT
Short Description
Data is being buffered for a later stage of the execution plan - and possibly being sorted too.
Where to use​
Sorting is one of the key stages in queries and it is important to ensure that these do not spill to disc by setting the pga_aggregate_target size.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.